﻿CREATE TABLE [dbo].[Customers] (
    [CustomerId] INT            IDENTITY (1, 1) NOT NULL,
    [FirstName]  NVARCHAR (150) NOT NULL,
    [LastName]   NVARCHAR (150) NULL,
    [Road]       NVARCHAR (150) NULL,
    [ZipCode]    NVARCHAR (10)  NULL,
    [City]       NVARCHAR (50)  NULL,
    [Country]    NVARCHAR (50)  NULL,
    [Telephone]  NCHAR (15)     NULL,
	[HomeTel]  NCHAR (15)     NULL,
    [Mobi]       NCHAR (15)     NULL,
    [Email]      NVARCHAR (50)  NULL,
    [Birthday]   DATETIME       NULL,
	[Description]   NVARCHAR (1500) NULL
);

